Tabela Action

Definicja tabeli Action

Name

Action

Code

Action

Comment

PL:Tabela na potrzeby logowania akcji aplikacji
EN: Action log table
DE: Die Tabelle fur die Aktion

PL: Tabela czynnosci
EN: Action table
DE: Die Tabelle fur die Aktion


Lista kolumn tabeli Action

Name

Code

ActionID

ActionID

RecordValueID

RecordValueID

Rec_RecordValueID

Rec_RecordValueID

ActionTypeID

ActionTypeID

PersonID

PersonID

SysFctID

SysFctID

ActionDT

ActionDT

Comments

Comments

TableName

TableName

Value

Value


Kolumna ActionID tabeli Action

Definicja kolumny ActionID tabeli Action

Name

ActionID

Code

ActionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna RecordValueID tabeli Action

Definicja kolumny RecordValueID tabeli Action

Name

RecordValueID

Code

RecordValueID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Rec_RecordValueID tabeli Action

Definicja kolumny Rec_RecordValueID tabeli Action

Name

Rec_RecordValueID

Code

Rec_RecordValueID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ActionTypeID tabeli Action

Definicja kolumny ActionTypeID tabeli Action

Name

ActionTypeID

Code

ActionTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli Action

Definicja kolumny PersonID tabeli Action

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna SysFctID tabeli Action

Definicja kolumny SysFctID tabeli Action

Name

SysFctID

Code

SysFctID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ActionDT tabeli Action

Definicja kolumny ActionDT tabeli Action

Name

ActionDT

Code

ActionDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Comments tabeli Action

Definicja kolumny Comments tabeli Action

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna TableName tabeli Action

Definicja kolumny TableName tabeli Action

Name

TableName

Code

TableName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Value tabeli Action

Definicja kolumny Value tabeli Action

Name

Value

Code

Value

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli Action

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Action

Definicja klucza Identifier_1 tabeli Action

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment